This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
An item I think would be very useful in Notes client applications would be if we could add, as part of an editable column, a formula which would dictate a list of legal values for that column.
- If the formula returns a list, expose that list as a drop-down list from the 'cell'. If the formula returns no values (or null or whatever) then there is no drop-down.
- The view would evaluate the formula just before the first pass through the InViewEdit event. This way, when the user clicks into the column, the drop down list is available, or not, and populated depending on the current state of the document. This would be much more user-friendly than working with Prompts from within InViewEdit.
- There could also be an 'allow values not in list' checkbox, which would of course be moot if the formula returns no values.
- For validating the user's selection(s), we could expose the column-values formula as a string property of the notesviewcolumn, which could then be evaluated during the validation pass through InViewEdit.
I'm not sure how multiple selections would be represented on screen, or captured into storage. For example if the formula returned a keyword list of "A":"B":"C", and 'allow other values' was checked, how would the column treat the user's ignoring the drop down list and instead typing in "A, B"? Does that represent a single custom value or two existing, defined values?
This feature would be incredibly useful in the sort of apps we do all the time.